Table des matières
Sujets
Recherche

create table conso (
numcons integer primary key ,
libcons varchar(30) not null,
prixcons numeric(6,2) not null check(prixcons between 1 and 10)
);
create table tables(
numtable integer primary key,
nomtable varchar(30) not null,
nbplaces smallint not null
);
create table serveur (
numserv integer primary key,
nomserv varchar(30) not null,
rueserv varchar(30),
cpserv char(5),
villeserv varchar(30),
datenaiss date
);
create table facture (
numfact integer primary key,
numtable integer references tables(numtable) ,
numserv integer references serveur(numserv),
datefact date not null
);
create table ligne_fact (
numfact integer references facture(numfact) on delete cascade,
numcons integer references conso(numcons),
qte smallint not null,
primary key(numfact,numcons)
);

Help image Générée avec chmProcessor